﻿CREATE TABLE [org].[LegalEntity] (
    [LegalEntityId]          INT             NOT NULL,
    [LegalEntityCode]        CHAR (5)        NOT NULL,
    [LegalEntityName]        VARCHAR (50)    NOT NULL,
    [LegalEntityDescription] NVARCHAR (1000) NULL,
    [LegalEntityStartDate]   DATE            NOT NULL,
    [LegalEntityEndDate]     DATE            NULL,
    [IsLatest]               BIT             NOT NULL,
    [IsActive]               BIT             NOT NULL,
    [IsInternal]             BIT             NOT NULL,
    PRIMARY KEY CLUSTERED ([LegalEntityId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

